﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dsInventarios" targetNamespace="http://tempuri.org/dsInventarios.xsd" xmlns:mstns="http://tempuri.org/dsInventarios.xsd" xmlns="http://tempuri.org/dsInventarios.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="3" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="ConnectionString5" IsAppSettingsProperty="true" Modifier="Assembly" Name="ConnectionString5 (MySettings)" ParameterPrefix=":" PropertyReference="ApplicationSettings.lbGlobalcom.My.MySettings.GlobalReference.Default.ConnectionString5" Provider="Oracle.DataAccess.Client" />
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="ConnectionString1" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ConnectionString1 (MySettings)" ParameterPrefix=":" PropertyReference="ApplicationSettings.lbGlobalcom.My.MySettings.GlobalReference.Default.ConnectionString1" Provider="Oracle.DataAccess.Client" />
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ConnectionString (MySettings)" ParameterPrefix=":" PropertyReference="ApplicationSettings.lbGlobalcom.My.MySettings.GlobalReference.Default.ConnectionString" Provider="System.Data.OracleClient" />
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="ConnectionString6" IsAppSettingsProperty="true" Modifier="Assembly" Name="ConnectionString6 (MySettings)" ParameterPrefix=":" PropertyReference="ApplicationSettings.lbGlobalcom.My.MySettings.GlobalReference.Default.ConnectionString6" Provider="Oracle.DataAccess.Client" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PRO_PRODUCTOTableAdapter" GeneratorDataComponentClassName="PRO_PRODUCTOTableAdapter" Name="PRO_PRODUCTO" UserDataComponentName="PRO_PRODUCTOTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.PRO_PRODUCTO" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "SAMUEL"."PRO_PRODUCTO" WHERE (("IDPRODUCTO" = :Original_IDPRODUCTO) AND ((:IsNull_DESCRICION = 1 AND "DESCRICION" IS NULL) OR ("DESCRICION" = :Original_DESCRICION)) AND ((:IsNull_APLICARANGODTO = 1 AND "APLICARANGODTO" IS NULL) OR ("APLICARANGODTO" = :Original_APLICARANGODTO)) AND ((:IsNull_CONTENIDO = 1 AND "CONTENIDO" IS NULL) OR ("CONTENIDO" = :Original_CONTENIDO)) AND ((:IsNull_COSTO = 1 AND "COSTO" IS NULL) OR ("COSTO" = :Original_COSTO)) AND ((:IsNull_EAN = 1 AND "EAN" IS NULL) OR ("EAN" = :Original_EAN)) AND ((:IsNull_ESTADO = 1 AND "ESTADO" IS NULL) OR ("ESTADO" = :Original_ESTADO)) AND ((:IsNull_IDTIPOIVA = 1 AND "IDTIPOIVA" IS NULL) OR ("IDTIPOIVA" = :Original_IDTIPOIVA)) AND ((:IsNull_IDTIPOPRODUCTO = 1 AND "IDTIPOPRODUCTO" IS NULL) OR ("IDTIPOPRODUCTO" = :Original_IDTIPOPRODUCTO)) AND ((:IsNull_REFERENCIA = 1 AND "REFERENCIA" IS NULL) OR ("REFERENCIA" = :Original_REFERENCIA)) AND ((:IsNull_UNIDAD = 1 AND "UNIDAD" IS NULL) OR ("UNIDAD" = :Original_UNIDAD)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRICION" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="DESCRICION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRICION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRICION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_APLICARANGODTO" Precision="0" ProviderType="Int32" Scale="0" Size="1" SourceColumn="APLICARANGODTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_APLICARANGODTO" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="APLICARANGODTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CONTENIDO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="CONTENIDO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_CONTENIDO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CONTENIDO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_COSTO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="COSTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_COSTO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COSTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_EAN" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="EAN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_EAN" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="EAN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ESTADO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="ESTADO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_ESTADO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="ESTADO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDTIPOIVA" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDTIPOIVA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDTIPOIVA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOIVA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDTIPOPRODUCTO" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDTIPOPRODUCTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDTIPOPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_REFERENCIA" Precision="0" ProviderType="Int32" Scale="0" Size="15" SourceColumn="REFERENCIA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_REFERENCIA" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="REFERENCIA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_UNIDAD" Precision="0" ProviderType="Int32" Scale="0" Size="10" SourceColumn="UNIDAD" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_UNIDAD" Precision="0" ProviderType="Varchar2" Scale="0" Size="10" SourceColumn="UNIDAD" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "SAMUEL"."PRO_PRODUCTO" ("IDPRODUCTO", "DESCRICION", "APLICARANGODTO", "CONTENIDO", "COSTO", "EAN", "ESTADO", "IDTIPOIVA", "IDTIPOPRODUCTO", "REFERENCIA", "UNIDAD") VALUES (:IDPRODUCTO, :DESCRICION, :APLICARANGODTO, :CONTENIDO, :COSTO, :EAN, :ESTADO, :IDTIPOIVA, :IDTIPOPRODUCTO, :REFERENCIA, :UNIDAD)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRICION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRICION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="APLICARANGODTO" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="APLICARANGODTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="CONTENIDO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CONTENIDO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="COSTO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COSTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="EAN" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="EAN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ESTADO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="ESTADO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDTIPOIVA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOIVA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDTIPOPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="REFERENCIA" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="REFERENCIA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="UNIDAD" Precision="0" ProviderType="Varchar2" Scale="0" Size="10" SourceColumn="UNIDAD" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDPRODUCTO, DESCRICION, APLICARANGODTO, CONTENIDO, COSTO, EAN, ESTADO, IDTIPOIVA, IDTIPOPRODUCTO, REFERENCIA, UNIDAD FROM SAMUEL.PRO_PRODUCTO</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "SAMUEL"."PRO_PRODUCTO" SET "IDPRODUCTO" = :IDPRODUCTO, "DESCRICION" = :DESCRICION, "APLICARANGODTO" = :APLICARANGODTO, "CONTENIDO" = :CONTENIDO, "COSTO" = :COSTO, "EAN" = :EAN, "ESTADO" = :ESTADO, "IDTIPOIVA" = :IDTIPOIVA, "IDTIPOPRODUCTO" = :IDTIPOPRODUCTO, "REFERENCIA" = :REFERENCIA, "UNIDAD" = :UNIDAD WHERE (("IDPRODUCTO" = :Original_IDPRODUCTO) AND ((:IsNull_DESCRICION = 1 AND "DESCRICION" IS NULL) OR ("DESCRICION" = :Original_DESCRICION)) AND ((:IsNull_APLICARANGODTO = 1 AND "APLICARANGODTO" IS NULL) OR ("APLICARANGODTO" = :Original_APLICARANGODTO)) AND ((:IsNull_CONTENIDO = 1 AND "CONTENIDO" IS NULL) OR ("CONTENIDO" = :Original_CONTENIDO)) AND ((:IsNull_COSTO = 1 AND "COSTO" IS NULL) OR ("COSTO" = :Original_COSTO)) AND ((:IsNull_EAN = 1 AND "EAN" IS NULL) OR ("EAN" = :Original_EAN)) AND ((:IsNull_ESTADO = 1 AND "ESTADO" IS NULL) OR ("ESTADO" = :Original_ESTADO)) AND ((:IsNull_IDTIPOIVA = 1 AND "IDTIPOIVA" IS NULL) OR ("IDTIPOIVA" = :Original_IDTIPOIVA)) AND ((:IsNull_IDTIPOPRODUCTO = 1 AND "IDTIPOPRODUCTO" IS NULL) OR ("IDTIPOPRODUCTO" = :Original_IDTIPOPRODUCTO)) AND ((:IsNull_REFERENCIA = 1 AND "REFERENCIA" IS NULL) OR ("REFERENCIA" = :Original_REFERENCIA)) AND ((:IsNull_UNIDAD = 1 AND "UNIDAD" IS NULL) OR ("UNIDAD" = :Original_UNIDAD)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRICION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRICION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="APLICARANGODTO" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="APLICARANGODTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="CONTENIDO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CONTENIDO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="COSTO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COSTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="EAN" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="EAN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ESTADO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="ESTADO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDTIPOIVA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOIVA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDTIPOPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="REFERENCIA" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="REFERENCIA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="UNIDAD" Precision="0" ProviderType="Varchar2" Scale="0" Size="10" SourceColumn="UNIDAD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRICION" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="DESCRICION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRICION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRICION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_APLICARANGODTO" Precision="0" ProviderType="Int32" Scale="0" Size="1" SourceColumn="APLICARANGODTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_APLICARANGODTO" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="APLICARANGODTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CONTENIDO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="CONTENIDO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_CONTENIDO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CONTENIDO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_COSTO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="COSTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_COSTO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COSTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_EAN" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="EAN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_EAN" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="EAN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ESTADO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="ESTADO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_ESTADO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="ESTADO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDTIPOIVA" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDTIPOIVA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDTIPOIVA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOIVA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDTIPOPRODUCTO" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDTIPOPRODUCTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDTIPOPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_REFERENCIA" Precision="0" ProviderType="Int32" Scale="0" Size="15" SourceColumn="REFERENCIA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_REFERENCIA" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="REFERENCIA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_UNIDAD" Precision="0" ProviderType="Int32" Scale="0" Size="10" SourceColumn="UNIDAD" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_UNIDAD" Precision="0" ProviderType="Varchar2" Scale="0" Size="10" SourceColumn="UNIDAD" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDPRODUCTO" DataSetColumn="IDPRODUCTO" />
              <Mapping SourceColumn="DESCRICION" DataSetColumn="DESCRICION" />
              <Mapping SourceColumn="APLICARANGODTO" DataSetColumn="APLICARANGODTO" />
              <Mapping SourceColumn="CONTENIDO" DataSetColumn="CONTENIDO" />
              <Mapping SourceColumn="COSTO" DataSetColumn="COSTO" />
              <Mapping SourceColumn="EAN" DataSetColumn="EAN" />
              <Mapping SourceColumn="ESTADO" DataSetColumn="ESTADO" />
              <Mapping SourceColumn="IDTIPOIVA" DataSetColumn="IDTIPOIVA" />
              <Mapping SourceColumn="IDTIPOPRODUCTO" DataSetColumn="IDTIPOPRODUCTO" />
              <Mapping SourceColumn="REFERENCIA" DataSetColumn="REFERENCIA" />
              <Mapping SourceColumn="UNIDAD" DataSetColumn="UNIDAD" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PRO_TIPOPRODUCTOTableAdapter" GeneratorDataComponentClassName="PRO_TIPOPRODUCTOTableAdapter" Name="PRO_TIPOPRODUCTO" UserDataComponentName="PRO_TIPOPRODUCTOTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.PRO_TIPOPRODUCTO" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "SAMUEL"."PRO_TIPOPRODUCTO" WHERE (("IDTIPOPRODUCTO" = :Original_IDTIPOPRODUCTO) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDTIPOPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "SAMUEL"."PRO_TIPOPRODUCTO" ("IDTIPOPRODUCTO", "DESCRIPCION") VALUES (:IDTIPOPRODUCTO, :DESCRIPCION)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDTIPOPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDTIPOPRODUCTO, DESCRIPCION FROM SAMUEL.PRO_TIPOPRODUCTO</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "SAMUEL"."PRO_TIPOPRODUCTO" SET "IDTIPOPRODUCTO" = :IDTIPOPRODUCTO, "DESCRIPCION" = :DESCRIPCION WHERE (("IDTIPOPRODUCTO" = :Original_IDTIPOPRODUCTO) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDTIPOPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDTIPOPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDTIPOPRODUCTO" DataSetColumn="IDTIPOPRODUCTO" />
              <Mapping SourceColumn="DESCRIPCION" DataSetColumn="DESCRIPCION" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="INV_INVENTARIOSTableAdapter" GeneratorDataComponentClassName="INV_INVENTARIOSTableAdapter" Name="INV_INVENTARIOS" UserDataComponentName="INV_INVENTARIOSTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.INV_INVENTARIOS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "INV_INVENTARIOS" WHERE (("IDBODEGA" = :Original_IDBODEGA) AND ("IDPRODUCTO" = :Original_IDPRODUCTO) AND ("PERIODO" = :Original_PERIODO) AND ("IDCLIENTE" = :Original_IDCLIENTE) AND ((:IsNull_COMPRA = 1 AND "COMPRA" IS NULL) OR ("COMPRA" = :Original_COMPRA)) AND ((:IsNull_COSTOPROMEDIO = 1 AND "COSTOPROMEDIO" IS NULL) OR ("COSTOPROMEDIO" = :Original_COSTOPROMEDIO)) AND ((:IsNull_ENTRADAS = 1 AND "ENTRADAS" IS NULL) OR ("ENTRADAS" = :Original_ENTRADAS)) AND ((:IsNull_SALDOINICIAL = 1 AND "SALDOINICIAL" IS NULL) OR ("SALDOINICIAL" = :Original_SALDOINICIAL)) AND ((:IsNull_SALIDAS = 1 AND "SALIDAS" IS NULL) OR ("SALIDAS" = :Original_SALIDAS)) AND ((:IsNull_VENTAPROMEDIO = 1 AND "VENTAPROMEDIO" IS NULL) OR ("VENTAPROMEDIO" = :Original_VENTAPROMEDIO)) AND ((:IsNull_VENTAS = 1 AND "VENTAS" IS NULL) OR ("VENTAS" = :Original_VENTAS)) AND ((:IsNull_ENTRADASPROMEDIO = 1 AND "ENTRADASPROMEDIO" IS NULL) OR ("ENTRADASPROMEDIO" = :Original_ENTRADASPROMEDIO)) AND ((:IsNull_SALIDASPROMEDIO = 1 AND "SALIDASPROMEDIO" IS NULL) OR ("SALIDASPROMEDIO" = :Original_SALIDASPROMEDIO)) AND ((:IsNull_INICIALPROMEDIO = 1 AND "INICIALPROMEDIO" IS NULL) OR ("INICIALPROMEDIO" = :Original_INICIALPROMEDIO)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDBODEGA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDBODEGA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_PERIODO" Precision="0" ProviderType="Varchar2" Scale="0" Size="6" SourceColumn="PERIODO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCLIENTE" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDCLIENTE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_COMPRA" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="COMPRA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_COMPRA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COMPRA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_COSTOPROMEDIO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="COSTOPROMEDIO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_COSTOPROMEDIO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COSTOPROMEDIO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ENTRADAS" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="ENTRADAS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_ENTRADAS" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="ENTRADAS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_SALDOINICIAL" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="SALDOINICIAL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_SALDOINICIAL" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SALDOINICIAL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_SALIDAS" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="SALIDAS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_SALIDAS" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SALIDAS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VENTAPROMEDIO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="VENTAPROMEDIO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VENTAPROMEDIO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VENTAPROMEDIO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VENTAS" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="VENTAS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VENTAS" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VENTAS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ENTRADASPROMEDIO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="ENTRADASPROMEDIO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_ENTRADASPROMEDIO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="ENTRADASPROMEDIO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_SALIDASPROMEDIO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="SALIDASPROMEDIO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_SALIDASPROMEDIO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SALIDASPROMEDIO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_INICIALPROMEDIO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="INICIALPROMEDIO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_INICIALPROMEDIO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="INICIALPROMEDIO" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "INV_INVENTARIOS" ("IDBODEGA", "IDPRODUCTO", "PERIODO", "IDCLIENTE", "COMPRA", "COSTOPROMEDIO", "ENTRADAS", "SALDOINICIAL", "SALIDAS", "VENTAPROMEDIO", "VENTAS", "ENTRADASPROMEDIO", "SALIDASPROMEDIO", "INICIALPROMEDIO") VALUES (:IDBODEGA, :IDPRODUCTO, :PERIODO, :IDCLIENTE, :COMPRA, :COSTOPROMEDIO, :ENTRADAS, :SALDOINICIAL, :SALIDAS, :VENTAPROMEDIO, :VENTAS, :ENTRADASPROMEDIO, :SALIDASPROMEDIO, :INICIALPROMEDIO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDBODEGA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDBODEGA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="PERIODO" Precision="0" ProviderType="Varchar2" Scale="0" Size="6" SourceColumn="PERIODO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCLIENTE" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDCLIENTE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="COMPRA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COMPRA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="COSTOPROMEDIO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COSTOPROMEDIO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ENTRADAS" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="ENTRADAS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="SALDOINICIAL" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SALDOINICIAL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="SALIDAS" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SALIDAS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VENTAPROMEDIO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VENTAPROMEDIO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VENTAS" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VENTAS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ENTRADASPROMEDIO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="ENTRADASPROMEDIO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="SALIDASPROMEDIO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SALIDASPROMEDIO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="INICIALPROMEDIO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="INICIALPROMEDIO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT IDBODEGA, IDPRODUCTO, PERIODO, IDCLIENTE, COMPRA, COSTOPROMEDIO, ENTRADAS, SALDOINICIAL, SALIDAS, VENTAPROMEDIO, VENTAS, ENTRADASPROMEDIO, SALIDASPROMEDIO, INICIALPROMEDIO, SALDOINICIAL + COMPRA + ENTRADAS - SALIDAS - VENTAS AS SALDO FROM INV_INVENTARIOS</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "INV_INVENTARIOS" SET "IDBODEGA" = :IDBODEGA, "IDPRODUCTO" = :IDPRODUCTO, "PERIODO" = :PERIODO, "IDCLIENTE" = :IDCLIENTE, "COMPRA" = :COMPRA, "COSTOPROMEDIO" = :COSTOPROMEDIO, "ENTRADAS" = :ENTRADAS, "SALDOINICIAL" = :SALDOINICIAL, "SALIDAS" = :SALIDAS, "VENTAPROMEDIO" = :VENTAPROMEDIO, "VENTAS" = :VENTAS, "ENTRADASPROMEDIO" = :ENTRADASPROMEDIO, "SALIDASPROMEDIO" = :SALIDASPROMEDIO, "INICIALPROMEDIO" = :INICIALPROMEDIO WHERE (("IDBODEGA" = :Original_IDBODEGA) AND ("IDPRODUCTO" = :Original_IDPRODUCTO) AND ("PERIODO" = :Original_PERIODO) AND ("IDCLIENTE" = :Original_IDCLIENTE) AND ((:IsNull_COMPRA = 1 AND "COMPRA" IS NULL) OR ("COMPRA" = :Original_COMPRA)) AND ((:IsNull_COSTOPROMEDIO = 1 AND "COSTOPROMEDIO" IS NULL) OR ("COSTOPROMEDIO" = :Original_COSTOPROMEDIO)) AND ((:IsNull_ENTRADAS = 1 AND "ENTRADAS" IS NULL) OR ("ENTRADAS" = :Original_ENTRADAS)) AND ((:IsNull_SALDOINICIAL = 1 AND "SALDOINICIAL" IS NULL) OR ("SALDOINICIAL" = :Original_SALDOINICIAL)) AND ((:IsNull_SALIDAS = 1 AND "SALIDAS" IS NULL) OR ("SALIDAS" = :Original_SALIDAS)) AND ((:IsNull_VENTAPROMEDIO = 1 AND "VENTAPROMEDIO" IS NULL) OR ("VENTAPROMEDIO" = :Original_VENTAPROMEDIO)) AND ((:IsNull_VENTAS = 1 AND "VENTAS" IS NULL) OR ("VENTAS" = :Original_VENTAS)) AND ((:IsNull_ENTRADASPROMEDIO = 1 AND "ENTRADASPROMEDIO" IS NULL) OR ("ENTRADASPROMEDIO" = :Original_ENTRADASPROMEDIO)) AND ((:IsNull_SALIDASPROMEDIO = 1 AND "SALIDASPROMEDIO" IS NULL) OR ("SALIDASPROMEDIO" = :Original_SALIDASPROMEDIO)) AND ((:IsNull_INICIALPROMEDIO = 1 AND "INICIALPROMEDIO" IS NULL) OR ("INICIALPROMEDIO" = :Original_INICIALPROMEDIO)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDBODEGA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDBODEGA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="PERIODO" Precision="0" ProviderType="Varchar2" Scale="0" Size="6" SourceColumn="PERIODO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCLIENTE" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDCLIENTE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="COMPRA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COMPRA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="COSTOPROMEDIO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COSTOPROMEDIO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ENTRADAS" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="ENTRADAS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="SALDOINICIAL" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SALDOINICIAL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="SALIDAS" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SALIDAS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VENTAPROMEDIO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VENTAPROMEDIO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VENTAS" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VENTAS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ENTRADASPROMEDIO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="ENTRADASPROMEDIO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="SALIDASPROMEDIO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SALIDASPROMEDIO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="INICIALPROMEDIO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="INICIALPROMEDIO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDBODEGA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDBODEGA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_PERIODO" Precision="0" ProviderType="Varchar2" Scale="0" Size="6" SourceColumn="PERIODO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCLIENTE" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDCLIENTE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_COMPRA" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="COMPRA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_COMPRA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COMPRA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_COSTOPROMEDIO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="COSTOPROMEDIO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_COSTOPROMEDIO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COSTOPROMEDIO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ENTRADAS" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="ENTRADAS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_ENTRADAS" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="ENTRADAS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_SALDOINICIAL" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="SALDOINICIAL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_SALDOINICIAL" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SALDOINICIAL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_SALIDAS" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="SALIDAS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_SALIDAS" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SALIDAS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VENTAPROMEDIO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="VENTAPROMEDIO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VENTAPROMEDIO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VENTAPROMEDIO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VENTAS" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="VENTAS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VENTAS" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VENTAS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ENTRADASPROMEDIO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="ENTRADASPROMEDIO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_ENTRADASPROMEDIO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="ENTRADASPROMEDIO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_SALIDASPROMEDIO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="SALIDASPROMEDIO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_SALIDASPROMEDIO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SALIDASPROMEDIO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_INICIALPROMEDIO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="INICIALPROMEDIO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_INICIALPROMEDIO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="INICIALPROMEDIO" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDBODEGA" DataSetColumn="IDBODEGA" />
              <Mapping SourceColumn="IDPRODUCTO" DataSetColumn="IDPRODUCTO" />
              <Mapping SourceColumn="PERIODO" DataSetColumn="PERIODO" />
              <Mapping SourceColumn="IDCLIENTE" DataSetColumn="IDCLIENTE" />
              <Mapping SourceColumn="COMPRA" DataSetColumn="COMPRA" />
              <Mapping SourceColumn="COSTOPROMEDIO" DataSetColumn="COSTOPROMEDIO" />
              <Mapping SourceColumn="ENTRADAS" DataSetColumn="ENTRADAS" />
              <Mapping SourceColumn="SALDOINICIAL" DataSetColumn="SALDOINICIAL" />
              <Mapping SourceColumn="SALIDAS" DataSetColumn="SALIDAS" />
              <Mapping SourceColumn="VENTAPROMEDIO" DataSetColumn="VENTAPROMEDIO" />
              <Mapping SourceColumn="VENTAS" DataSetColumn="VENTAS" />
              <Mapping SourceColumn="ENTRADASPROMEDIO" DataSetColumn="ENTRADASPROMEDIO" />
              <Mapping SourceColumn="SALIDASPROMEDIO" DataSetColumn="SALIDASPROMEDIO" />
              <Mapping SourceColumn="INICIALPROMEDIO" DataSetColumn="INICIALPROMEDIO" />
              <Mapping SourceColumn="SALDO" DataSetColumn="SALDO" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.INV_INVENTARIOS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByBodegaProductoPeriodoCliente" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByBodegaProductoPeriodoCliente" GeneratorSourceName="FillByBodegaProductoPeriodoCliente" GetMethodModifier="Public" GetMethodName="GetDataByBodegaProductoPeriodoCliente" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByBodegaProductoPeriodoCliente" UserSourceName="FillByBodegaProductoPeriodoCliente">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT COMPRA, COSTOPROMEDIO, ENTRADAS, ENTRADASPROMEDIO, IDBODEGA, IDCLIENTE, IDPRODUCTO, INICIALPROMEDIO, PERIODO, SALDOINICIAL, SALIDAS, SALIDASPROMEDIO, VENTAPROMEDIO, VENTAS FROM INV_INVENTARIOS WHERE (IDBODEGA = :PIDBODEGA) AND (IDPRODUCTO = :PIDPRODUCTO) AND (PERIODO = :PPERIODO) AND (IDCLIENTE = :PCLIENTE)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PIDBODEGA" ColumnName="IDBODEGA" DataSourceName="SAMUEL.INV_INVENTARIOS" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PIDBODEGA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDBODEGA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PIDPRODUCTO" ColumnName="IDPRODUCTO" DataSourceName="SAMUEL.INV_INVENTARIOS" DataTypeServer="VARCHAR2(15)" DbType="String" Direction="Input" ParameterName=":PIDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PPERIODO" ColumnName="PERIODO" DataSourceName="SAMUEL.INV_INVENTARIOS" DataTypeServer="VARCHAR2(6)" DbType="String" Direction="Input" ParameterName=":PPERIODO" Precision="0" ProviderType="Varchar2" Scale="0" Size="6" SourceColumn="PERIODO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PCLIENTE" ColumnName="IDCLIENTE" DataSourceName="SAMUEL.INV_INVENTARIOS" DataTypeServer="VARCHAR2(15)" DbType="String" Direction="Input" ParameterName=":PCLIENTE" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDCLIENTE" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="INV_DETALLEINVENTARIOSTableAdapter" GeneratorDataComponentClassName="INV_DETALLEINVENTARIOSTableAdapter" Name="INV_DETALLEINVENTARIOS" UserDataComponentName="INV_DETALLEINVENTARIOSTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.INV_DETALLEINVENTARIOS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "SAMUEL"."INV_DETALLEINVENTARIOS" WHERE (("IDBODEGA" = :Original_IDBODEGA) AND ("IDPRODUCTO" = :Original_IDPRODUCTO) AND ("CONSECUTIVO" = :Original_CONSECUTIVO) AND ("IMEI" = :Original_IMEI) AND ("ICCID" = :Original_ICCID) AND ((:IsNull_COSTO = 1 AND "COSTO" IS NULL) OR ("COSTO" = :Original_COSTO)) AND ("FECHAINGRESO" = :Original_FECHAINGRESO) AND ((:IsNull_SALDO = 1 AND "SALDO" IS NULL) OR ("SALDO" = :Original_SALDO)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDBODEGA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDBODEGA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_CONSECUTIVO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CONSECUTIVO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IMEI" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="IMEI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ICCID" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="ICCID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_COSTO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="COSTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_COSTO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COSTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="Original_FECHAINGRESO" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHAINGRESO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_SALDO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="SALDO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_SALDO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SALDO" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "SAMUEL"."INV_DETALLEINVENTARIOS" ("IDBODEGA", "IDPRODUCTO", "CONSECUTIVO", "IMEI", "ICCID", "COSTO", "FECHAINGRESO", "SALDO") VALUES (:IDBODEGA, :IDPRODUCTO, :CONSECUTIVO, :IMEI, :ICCID, :COSTO, :FECHAINGRESO, :SALDO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDBODEGA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDBODEGA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="CONSECUTIVO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CONSECUTIVO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IMEI" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="IMEI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ICCID" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="ICCID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="COSTO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COSTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="FECHAINGRESO" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHAINGRESO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="SALDO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SALDO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDBODEGA, IDPRODUCTO, CONSECUTIVO, IMEI, ICCID, COSTO, FECHAINGRESO, SALDO FROM SAMUEL.INV_DETALLEINVENTARIOS</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "SAMUEL"."INV_DETALLEINVENTARIOS" SET "IDBODEGA" = :IDBODEGA, "IDPRODUCTO" = :IDPRODUCTO, "CONSECUTIVO" = :CONSECUTIVO, "IMEI" = :IMEI, "ICCID" = :ICCID, "COSTO" = :COSTO, "FECHAINGRESO" = :FECHAINGRESO, "SALDO" = :SALDO WHERE (("IDBODEGA" = :Original_IDBODEGA) AND ("IDPRODUCTO" = :Original_IDPRODUCTO) AND ("CONSECUTIVO" = :Original_CONSECUTIVO) AND ("IMEI" = :Original_IMEI) AND ("ICCID" = :Original_ICCID) AND ((:IsNull_COSTO = 1 AND "COSTO" IS NULL) OR ("COSTO" = :Original_COSTO)) AND ("FECHAINGRESO" = :Original_FECHAINGRESO) AND ((:IsNull_SALDO = 1 AND "SALDO" IS NULL) OR ("SALDO" = :Original_SALDO)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDBODEGA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDBODEGA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="CONSECUTIVO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CONSECUTIVO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IMEI" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="IMEI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ICCID" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="ICCID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="COSTO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COSTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="FECHAINGRESO" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHAINGRESO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="SALDO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SALDO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDBODEGA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDBODEGA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_CONSECUTIVO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CONSECUTIVO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IMEI" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="IMEI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ICCID" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="ICCID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_COSTO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="COSTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_COSTO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COSTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="Original_FECHAINGRESO" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHAINGRESO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_SALDO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="SALDO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_SALDO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SALDO" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDBODEGA" DataSetColumn="IDBODEGA" />
              <Mapping SourceColumn="IDPRODUCTO" DataSetColumn="IDPRODUCTO" />
              <Mapping SourceColumn="CONSECUTIVO" DataSetColumn="CONSECUTIVO" />
              <Mapping SourceColumn="IMEI" DataSetColumn="IMEI" />
              <Mapping SourceColumn="ICCID" DataSetColumn="ICCID" />
              <Mapping SourceColumn="COSTO" DataSetColumn="COSTO" />
              <Mapping SourceColumn="FECHAINGRESO" DataSetColumn="FECHAINGRESO" />
              <Mapping SourceColumn="SALDO" DataSetColumn="SALDO" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.INV_DETALLEINVENTARIOS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdBodegaIdProducto" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdBodegaIdProducto" GeneratorSourceName="FillByIdBodegaIdProducto" GetMethodModifier="Public" GetMethodName="GetDataByIdBodegaIdProducto" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdBodegaIdProducto" UserSourceName="FillByIdBodegaIdProducto">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        IDBODEGA, IDPRODUCTO, CONSECUTIVO, IMEI, ICCID, COSTO, FECHAINGRESO, SALDO
FROM            INV_DETALLEINVENTARIOS
WHERE        (IDPRODUCTO = :PIDPRODUCTO) AND (IDBODEGA = :PIDBODEGA)
ORDER BY FECHAINGRESO, CONSECUTIVO</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PIDPRODUCTO" ColumnName="IDPRODUCTO" DataSourceName="SAMUEL.INV_DETALLEINVENTARIOS" DataTypeServer="VARCHAR2(15)" DbType="String" Direction="Input" ParameterName=":PIDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PIDBODEGA" ColumnName="IDBODEGA" DataSourceName="SAMUEL.INV_DETALLEINVENTARIOS" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PIDBODEGA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDBODEGA" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="INV_DETALLETableAdapter" GeneratorDataComponentClassName="INV_DETALLETableAdapter" Name="INV_DETALLE" UserDataComponentName="INV_DETALLETableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.INV_DETALLE" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "INV_DETALLE" ("IDBODEGA", "IDPRODUCTO", "TIPOSUBPROD", "NUMEROREGISTRO", "COSTO", "FECHAINGRESO", "CONSECUTIVO", "PAREJA") VALUES (:IDBODEGA, :IDPRODUCTO, :TIPOSUBPROD, :NUMEROREGISTRO, :COSTO, :FECHAINGRESO, :CONSECUTIVO, :PAREJA)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDBODEGA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDBODEGA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="TIPOSUBPROD" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="TIPOSUBPROD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="NUMEROREGISTRO" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="NUMEROREGISTRO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="COSTO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COSTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="FECHAINGRESO" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHAINGRESO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="CONSECUTIVO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CONSECUTIVO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="PAREJA" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="PAREJA" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     IDBODEGA, IDPRODUCTO, TIPOSUBPROD, NUMEROREGISTRO, COSTO, FECHAINGRESO, CONSECUTIVO, PAREJA
FROM         INV_DETALLE</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDBODEGA" DataSetColumn="IDBODEGA" />
              <Mapping SourceColumn="IDPRODUCTO" DataSetColumn="IDPRODUCTO" />
              <Mapping SourceColumn="TIPOSUBPROD" DataSetColumn="TIPOSUBPROD" />
              <Mapping SourceColumn="NUMEROREGISTRO" DataSetColumn="NUMEROREGISTRO" />
              <Mapping SourceColumn="COSTO" DataSetColumn="COSTO" />
              <Mapping SourceColumn="FECHAINGRESO" DataSetColumn="FECHAINGRESO" />
              <Mapping SourceColumn="CONSECUTIVO" DataSetColumn="CONSECUTIVO" />
              <Mapping SourceColumn="PAREJA" DataSetColumn="PAREJA" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.INV_DETALLE" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByDatosImeiIccid" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByDatosImeiIccid" GeneratorSourceName="FillByDatosImeiIccid" GetMethodModifier="Public" GetMethodName="GetDataByDatosImeiIccid" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByDatosImeiIccid" UserSourceName="FillByDatosImeiIccid">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     IDBODEGA, IDPRODUCTO, TIPOSUBPROD, NUMEROREGISTRO, COSTO, FECHAINGRESO, CONSECUTIVO, PAREJA
FROM         INV_DETALLE
WHERE   (NUMEROREGISTRO = :PNUMEROREGISTRO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="PNUMEROREGISTRO" ColumnName="NUMEROREGISTRO" DataSourceName="SAMUEL.INV_DETALLE" DataTypeServer="VARCHAR2(20)" DbType="String" Direction="Input" ParameterName=":PNUMEROREGISTRO" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="NUMEROREGISTRO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.INV_DETALLE" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdBodegaIdProdIdSubProd" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdBodegaIdProdIdSubProd" GeneratorSourceName="FillByIdBodegaIdProdIdSubProd" GetMethodModifier="Public" GetMethodName="GetDataByIdBodegaIdProdIdSubProd" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdBodegaIdProdIdSubProd" UserSourceName="FillByIdBodegaIdProdIdSubProd">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT CONSECUTIVO, COSTO, FECHAINGRESO, IDBODEGA, IDPRODUCTO, NUMEROREGISTRO, PAREJA, TIPOSUBPROD FROM INV_DETALLE WHERE (IDBODEGA = :PIDBODEGA) AND (IDPRODUCTO = :PIDPRODUCTO) AND (TIPOSUBPROD = :PTIPOSUBPROD)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="PIDBODEGA" ColumnName="IDBODEGA" DataSourceName="SAMUEL.INV_DETALLE" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PIDBODEGA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDBODEGA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="PIDPRODUCTO" ColumnName="IDPRODUCTO" DataSourceName="SAMUEL.INV_DETALLE" DataTypeServer="VARCHAR2(15)" DbType="String" Direction="Input" ParameterName=":PIDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="PTIPOSUBPROD" ColumnName="TIPOSUBPROD" DataSourceName="SAMUEL.INV_DETALLE" DataTypeServer="NUMBER(22)" DbType="Decimal" Direction="Input" ParameterName=":PTIPOSUBPROD" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="TIPOSUBPROD" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.INV_DETALLE" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByPareja" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByPareja" GeneratorSourceName="FillByPareja" GetMethodModifier="Public" GetMethodName="GetDataByPareja" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByPareja" UserSourceName="FillByPareja">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     IDBODEGA, IDPRODUCTO, TIPOSUBPROD, NUMEROREGISTRO, COSTO, FECHAINGRESO, CONSECUTIVO, PAREJA
FROM         INV_DETALLE
WHERE     (IDPRODUCTO = :PIDPRODUCTO) AND (TIPOSUBPROD = :PTIPOSUBPROD) AND (PAREJA = :PPAREJA) AND (CONSECUTIVO = :PCONSECUTIVO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="PIDPRODUCTO" ColumnName="IDPRODUCTO" DataSourceName="SAMUEL.INV_DETALLE" DataTypeServer="VARCHAR2(15)" DbType="String" Direction="Input" ParameterName=":PIDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="PTIPOSUBPROD" ColumnName="TIPOSUBPROD" DataSourceName="SAMUEL.INV_DETALLE" DataTypeServer="NUMBER(22)" DbType="Decimal" Direction="Input" ParameterName=":PTIPOSUBPROD" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="TIPOSUBPROD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="PPAREJA" ColumnName="PAREJA" DataSourceName="SAMUEL.INV_DETALLE" DataTypeServer="VARCHAR2(30)" DbType="String" Direction="Input" ParameterName=":PPAREJA" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="PAREJA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="PCONSECUTIVO" ColumnName="CONSECUTIVO" DataSourceName="SAMUEL.INV_DETALLE" DataTypeServer="NUMBER(22)" DbType="Decimal" Direction="Input" ParameterName=":PCONSECUTIVO" Precision="38" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CONSECUTIVO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="GetImeiIccidValido" Modifier="Public" Name="GetImeiIccidValido" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="GetImeiIccidValido">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     COUNT(*)
FROM         INV_DETALLE
WHERE  NUMEROREGISTRO=:PNUMEROREGISTRO</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="PNUMEROREGISTRO" ColumnName="NUMEROREGISTRO" DataSourceName="SAMUEL.INV_DETALLE" DataTypeServer="VARCHAR2(20)" DbType="String" Direction="Input" ParameterName=":PNUMEROREGISTRO" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="NUMEROREGISTRO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy1" GeneratorSourceName="validaExistenciaBodega" Modifier="Public" Name="validaExistenciaBodega" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="validaExistenciaBodega">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     COUNT(*) AS EXPR1
FROM         INV_DETALLE
WHERE     (IDBODEGA =:PBODEGA) AND (NUMEROREGISTRO =:PNUMEROREG)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="PBODEGA" ColumnName="IDBODEGA" DataSourceName="SAMUEL.INV_DETALLE" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PBODEGA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDBODEGA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="PNUMEROREG" ColumnName="NUMEROREGISTRO" DataSourceName="SAMUEL.INV_DETALLE" DataTypeServer="VARCHAR2(20)" DbType="String" Direction="Input" ParameterName=":PNUMEROREG" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="NUMEROREGISTRO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="INV_PREPACKTableAdapter" GeneratorDataComponentClassName="INV_PREPACKTableAdapter" Name="INV_PREPACK" UserDataComponentName="INV_PREPACKTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.INV_PREPACK" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "INV_PREPACK" WHERE (("IDPREPACK" = :Original_IDPREPACK) AND ("CONSECPREPACK" = :Original_CONSECPREPACK) AND ((:IsNull_COSTO = 1 AND "COSTO" IS NULL) OR ("COSTO" = :Original_COSTO)) AND ((:IsNull_FECHAPREPACK = 1 AND "FECHAPREPACK" IS NULL) OR ("FECHAPREPACK" = :Original_FECHAPREPACK)) AND ((:IsNull_ESTADO = 1 AND "ESTADO" IS NULL) OR ("ESTADO" = :Original_ESTADO)) AND ((:IsNull_IDPRODUCTOP = 1 AND "IDPRODUCTOP" IS NULL) OR ("IDPRODUCTOP" = :Original_IDPRODUCTOP)) AND ((:IsNull_IDPRODUCTOH = 1 AND "IDPRODUCTOH" IS NULL) OR ("IDPRODUCTOH" = :Original_IDPRODUCTOH)) AND ((:IsNull_TIPOSUBPROP = 1 AND "TIPOSUBPROP" IS NULL) OR ("TIPOSUBPROP" = :Original_TIPOSUBPROP)) AND ((:IsNull_NUMEROREGISTROP = 1 AND "NUMEROREGISTROP" IS NULL) OR ("NUMEROREGISTROP" = :Original_NUMEROREGISTROP)) AND ((:IsNull_TIPOSUBPRODH = 1 AND "TIPOSUBPRODH" IS NULL) OR ("TIPOSUBPRODH" = :Original_TIPOSUBPRODH)) AND ((:IsNull_NUMEROREGISTROH = 1 AND "NUMEROREGISTROH" IS NULL) OR ("NUMEROREGISTROH" = :Original_NUMEROREGISTROH)) AND ((:IsNull_PAREJA = 1 AND "PAREJA" IS NULL) OR ("PAREJA" = :Original_PAREJA)) AND ((:IsNull_IDTIPOPREPACK = 1 AND "IDTIPOPREPACK" IS NULL) OR ("IDTIPOPREPACK" = :Original_IDTIPOPREPACK)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_IDPREPACK" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="IDPREPACK" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_CONSECPREPACK" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CONSECPREPACK" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_COSTO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="COSTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_COSTO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COSTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FECHAPREPACK" Precision="0" ProviderType="Int32" Scale="0" Size="7" SourceColumn="FECHAPREPACK" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="Original_FECHAPREPACK" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHAPREPACK" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ESTADO" Precision="0" ProviderType="Int32" Scale="0" Size="1" SourceColumn="ESTADO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_ESTADO" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="ESTADO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDPRODUCTOP" Precision="0" ProviderType="Int32" Scale="0" Size="15" SourceColumn="IDPRODUCTOP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPRODUCTOP" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTOP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDPRODUCTOH" Precision="0" ProviderType="Int32" Scale="0" Size="15" SourceColumn="IDPRODUCTOH" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPRODUCTOH" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTOH" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_TIPOSUBPROP" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="TIPOSUBPROP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_TIPOSUBPROP" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="TIPOSUBPROP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NUMEROREGISTROP" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="NUMEROREGISTROP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_NUMEROREGISTROP" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="NUMEROREGISTROP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_TIPOSUBPRODH" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="TIPOSUBPRODH" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_TIPOSUBPRODH" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="TIPOSUBPRODH" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NUMEROREGISTROH" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="NUMEROREGISTROH" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_NUMEROREGISTROH" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="NUMEROREGISTROH" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PAREJA" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="PAREJA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_PAREJA" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="PAREJA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDTIPOPREPACK" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="IDTIPOPREPACK" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_IDTIPOPREPACK" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="IDTIPOPREPACK" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "INV_PREPACK" ("IDPREPACK", "CONSECPREPACK", "COSTO", "FECHAPREPACK", "ESTADO", "IDPRODUCTOP", "IDPRODUCTOH", "TIPOSUBPROP", "NUMEROREGISTROP", "TIPOSUBPRODH", "NUMEROREGISTROH", "PAREJA", "IDTIPOPREPACK") VALUES (:IDPREPACK, :CONSECPREPACK, :COSTO, :FECHAPREPACK, :ESTADO, :IDPRODUCTOP, :IDPRODUCTOH, :TIPOSUBPROP, :NUMEROREGISTROP, :TIPOSUBPRODH, :NUMEROREGISTROH, :PAREJA, :IDTIPOPREPACK)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="IDPREPACK" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="IDPREPACK" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="CONSECPREPACK" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CONSECPREPACK" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="COSTO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COSTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="FECHAPREPACK" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHAPREPACK" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="ESTADO" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="ESTADO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPRODUCTOP" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTOP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPRODUCTOH" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTOH" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="TIPOSUBPROP" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="TIPOSUBPROP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="NUMEROREGISTROP" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="NUMEROREGISTROP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="TIPOSUBPRODH" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="TIPOSUBPRODH" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="NUMEROREGISTROH" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="NUMEROREGISTROH" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="PAREJA" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="PAREJA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="IDTIPOPREPACK" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="IDTIPOPREPACK" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        IDPREPACK, CONSECPREPACK, COSTO, FECHAPREPACK, ESTADO, IDPRODUCTOP, IDPRODUCTOH, TIPOSUBPROP, NUMEROREGISTROP, 
                         TIPOSUBPRODH, NUMEROREGISTROH, PAREJA, IDTIPOPREPACK
FROM            INV_PREPACK</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "INV_PREPACK" SET "IDPREPACK" = :IDPREPACK, "CONSECPREPACK" = :CONSECPREPACK, "COSTO" = :COSTO, "FECHAPREPACK" = :FECHAPREPACK, "ESTADO" = :ESTADO, "IDPRODUCTOP" = :IDPRODUCTOP, "IDPRODUCTOH" = :IDPRODUCTOH, "TIPOSUBPROP" = :TIPOSUBPROP, "NUMEROREGISTROP" = :NUMEROREGISTROP, "TIPOSUBPRODH" = :TIPOSUBPRODH, "NUMEROREGISTROH" = :NUMEROREGISTROH, "PAREJA" = :PAREJA, "IDTIPOPREPACK" = :IDTIPOPREPACK WHERE (("IDPREPACK" = :Original_IDPREPACK) AND ("CONSECPREPACK" = :Original_CONSECPREPACK) AND ((:IsNull_COSTO = 1 AND "COSTO" IS NULL) OR ("COSTO" = :Original_COSTO)) AND ((:IsNull_FECHAPREPACK = 1 AND "FECHAPREPACK" IS NULL) OR ("FECHAPREPACK" = :Original_FECHAPREPACK)) AND ((:IsNull_ESTADO = 1 AND "ESTADO" IS NULL) OR ("ESTADO" = :Original_ESTADO)) AND ((:IsNull_IDPRODUCTOP = 1 AND "IDPRODUCTOP" IS NULL) OR ("IDPRODUCTOP" = :Original_IDPRODUCTOP)) AND ((:IsNull_IDPRODUCTOH = 1 AND "IDPRODUCTOH" IS NULL) OR ("IDPRODUCTOH" = :Original_IDPRODUCTOH)) AND ((:IsNull_TIPOSUBPROP = 1 AND "TIPOSUBPROP" IS NULL) OR ("TIPOSUBPROP" = :Original_TIPOSUBPROP)) AND ((:IsNull_NUMEROREGISTROP = 1 AND "NUMEROREGISTROP" IS NULL) OR ("NUMEROREGISTROP" = :Original_NUMEROREGISTROP)) AND ((:IsNull_TIPOSUBPRODH = 1 AND "TIPOSUBPRODH" IS NULL) OR ("TIPOSUBPRODH" = :Original_TIPOSUBPRODH)) AND ((:IsNull_NUMEROREGISTROH = 1 AND "NUMEROREGISTROH" IS NULL) OR ("NUMEROREGISTROH" = :Original_NUMEROREGISTROH)) AND ((:IsNull_PAREJA = 1 AND "PAREJA" IS NULL) OR ("PAREJA" = :Original_PAREJA)) AND ((:IsNull_IDTIPOPREPACK = 1 AND "IDTIPOPREPACK" IS NULL) OR ("IDTIPOPREPACK" = :Original_IDTIPOPREPACK)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="IDPREPACK" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="IDPREPACK" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="CONSECPREPACK" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CONSECPREPACK" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="COSTO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COSTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="FECHAPREPACK" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHAPREPACK" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="ESTADO" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="ESTADO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPRODUCTOP" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTOP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPRODUCTOH" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTOH" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="TIPOSUBPROP" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="TIPOSUBPROP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="NUMEROREGISTROP" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="NUMEROREGISTROP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="TIPOSUBPRODH" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="TIPOSUBPRODH" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="NUMEROREGISTROH" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="NUMEROREGISTROH" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="PAREJA" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="PAREJA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="IDTIPOPREPACK" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="IDTIPOPREPACK" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_IDPREPACK" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="IDPREPACK" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_CONSECPREPACK" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CONSECPREPACK" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_COSTO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="COSTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_COSTO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="COSTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FECHAPREPACK" Precision="0" ProviderType="Int32" Scale="0" Size="7" SourceColumn="FECHAPREPACK" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="Original_FECHAPREPACK" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHAPREPACK" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ESTADO" Precision="0" ProviderType="Int32" Scale="0" Size="1" SourceColumn="ESTADO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_ESTADO" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="ESTADO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDPRODUCTOP" Precision="0" ProviderType="Int32" Scale="0" Size="15" SourceColumn="IDPRODUCTOP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPRODUCTOP" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTOP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDPRODUCTOH" Precision="0" ProviderType="Int32" Scale="0" Size="15" SourceColumn="IDPRODUCTOH" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPRODUCTOH" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTOH" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_TIPOSUBPROP" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="TIPOSUBPROP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_TIPOSUBPROP" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="TIPOSUBPROP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NUMEROREGISTROP" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="NUMEROREGISTROP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_NUMEROREGISTROP" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="NUMEROREGISTROP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_TIPOSUBPRODH" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="TIPOSUBPRODH" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_TIPOSUBPRODH" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="TIPOSUBPRODH" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NUMEROREGISTROH" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="NUMEROREGISTROH" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_NUMEROREGISTROH" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="NUMEROREGISTROH" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PAREJA" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="PAREJA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_PAREJA" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="PAREJA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDTIPOPREPACK" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="IDTIPOPREPACK" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_IDTIPOPREPACK" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="IDTIPOPREPACK" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDPREPACK" DataSetColumn="IDPREPACK" />
              <Mapping SourceColumn="CONSECPREPACK" DataSetColumn="CONSECPREPACK" />
              <Mapping SourceColumn="COSTO" DataSetColumn="COSTO" />
              <Mapping SourceColumn="FECHAPREPACK" DataSetColumn="FECHAPREPACK" />
              <Mapping SourceColumn="ESTADO" DataSetColumn="ESTADO" />
              <Mapping SourceColumn="IDPRODUCTOP" DataSetColumn="IDPRODUCTOP" />
              <Mapping SourceColumn="IDPRODUCTOH" DataSetColumn="IDPRODUCTOH" />
              <Mapping SourceColumn="TIPOSUBPROP" DataSetColumn="TIPOSUBPROP" />
              <Mapping SourceColumn="NUMEROREGISTROP" DataSetColumn="NUMEROREGISTROP" />
              <Mapping SourceColumn="TIPOSUBPRODH" DataSetColumn="TIPOSUBPRODH" />
              <Mapping SourceColumn="NUMEROREGISTROH" DataSetColumn="NUMEROREGISTROH" />
              <Mapping SourceColumn="PAREJA" DataSetColumn="PAREJA" />
              <Mapping SourceColumn="IDTIPOPREPACK" DataSetColumn="IDTIPOPREPACK" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.INV_PREPACK" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByESTADO" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByESTADO" GeneratorSourceName="FillByESTADO" GetMethodModifier="Public" GetMethodName="GetDataByESTADO" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByESTADO" UserSourceName="FillByESTADO">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT CONSECPREPACK, COSTO, ESTADO, FECHAPREPACK, IDPREPACK, IDPRODUCTOH, IDPRODUCTOP, IDTIPOPREPACK, NUMEROREGISTROH, NUMEROREGISTROP, PAREJA, TIPOSUBPRODH, TIPOSUBPROP FROM INV_PREPACK WHERE (ESTADO = :PESTADO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="PESTADO" ColumnName="ESTADO" DataSourceName="SAMUEL.INV_PREPACK" DataTypeServer="CHAR(1)" DbType="String" Direction="Input" ParameterName=":PESTADO" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="ESTADO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.INV_PREPACK" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdPrepackConsec" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdPrepackConsec" GeneratorSourceName="FillByIdPrepackConsec" GetMethodModifier="Public" GetMethodName="GetDataByIdPrepackConsec" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdPrepackConsec" UserSourceName="FillByIdPrepackConsec">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT CONSECPREPACK, COSTO, ESTADO, FECHAPREPACK, IDPREPACK, IDPRODUCTOH, IDPRODUCTOP, IDTIPOPREPACK, NUMEROREGISTROH, NUMEROREGISTROP, PAREJA, TIPOSUBPRODH, TIPOSUBPROP FROM INV_PREPACK WHERE (IDPREPACK = :PIDPREPACK) AND (CONSECPREPACK = :PCONSECPREPACK)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PIDPREPACK" ColumnName="IDPREPACK" DataSourceName="SAMUEL.INV_PREPACK" DataTypeServer="NUMBER(22)" DbType="Decimal" Direction="Input" ParameterName=":PIDPREPACK" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="IDPREPACK" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PCONSECPREPACK" ColumnName="CONSECPREPACK" DataSourceName="SAMUEL.INV_PREPACK" DataTypeServer="NUMBER(22)" DbType="Decimal" Direction="Input" ParameterName=":PCONSECPREPACK" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CONSECPREPACK" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.INV_PREPACK" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByTipoNumeroH" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByTipoNumeroH" GeneratorSourceName="FillByTipoNumeroH" GetMethodModifier="Public" GetMethodName="GetDataByTipoNumeroH" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByTipoNumeroH" UserSourceName="FillByTipoNumeroH">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT CONSECPREPACK, COSTO, ESTADO, FECHAPREPACK, IDPREPACK, IDPRODUCTOH, IDPRODUCTOP, IDTIPOPREPACK, NUMEROREGISTROH, NUMEROREGISTROP, PAREJA, TIPOSUBPRODH, TIPOSUBPROP FROM INV_PREPACK WHERE (TIPOSUBPRODH = :PTIPOSUBPRODH) AND (NUMEROREGISTROH = :PNUMEROREGISTROH)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="PTIPOSUBPRODH" ColumnName="TIPOSUBPRODH" DataSourceName="SAMUEL.INV_PREPACK" DataTypeServer="NUMBER(22)" DbType="Decimal" Direction="Input" ParameterName=":PTIPOSUBPRODH" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="TIPOSUBPRODH" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="PNUMEROREGISTROH" ColumnName="NUMEROREGISTROH" DataSourceName="SAMUEL.INV_PREPACK" DataTypeServer="VARCHAR2(20)" DbType="String" Direction="Input" ParameterName=":PNUMEROREGISTROH" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="NUMEROREGISTROH" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.INV_PREPACK" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByTipoNumeroP" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByTipoNumeroP" GeneratorSourceName="FillByTipoNumeroP" GetMethodModifier="Public" GetMethodName="GetDataByTipoNumeroP" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByTipoNumeroP" UserSourceName="FillByTipoNumeroP">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT CONSECPREPACK, COSTO, ESTADO, FECHAPREPACK, IDPREPACK, IDPRODUCTOH, IDPRODUCTOP, IDTIPOPREPACK, NUMEROREGISTROH, NUMEROREGISTROP, PAREJA, TIPOSUBPRODH, TIPOSUBPROP FROM INV_PREPACK WHERE (TIPOSUBPROP = :PTIPOSUBPROP) AND (NUMEROREGISTROP = :PNUMEROREGISTROP)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="PTIPOSUBPROP" ColumnName="TIPOSUBPROP" DataSourceName="SAMUEL.INV_PREPACK" DataTypeServer="NUMBER(22)" DbType="Decimal" Direction="Input" ParameterName=":PTIPOSUBPROP" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="TIPOSUBPROP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PNUMEROREGISTROP" ColumnName="NUMEROREGISTROP" DataSourceName="SAMUEL.INV_PREPACK" DataTypeServer="VARCHAR2(20)" DbType="String" Direction="Input" ParameterName=":PNUMEROREGISTROP" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="NUMEROREGISTROP" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy1" GeneratorSourceName="GetIccidGuardado" Modifier="Public" Name="GetIccidGuardado" QueryType="Scalar" ScalarCallRetval="System.Decimal, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="GetIccidGuardado">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     COUNT(*) AS EXPR1
FROM         INV_PREPACK
WHERE     (IDPREPACK = :PIDPREPACK) AND (CONSECPREPACK = :PCONSECUTIVO) AND (IDPRODUCTOH = :PIDPRODUCTOH) AND 
                      (NUMEROREGISTROH = :PNUMEROREGISTROH)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PIDPREPACK" ColumnName="IDPREPACK" DataSourceName="SAMUEL.INV_PREPACK" DataTypeServer="NUMBER(22)" DbType="Decimal" Direction="Input" ParameterName=":PIDPREPACK" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="IDPREPACK" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PCONSECUTIVO" ColumnName="CONSECPREPACK" DataSourceName="SAMUEL.INV_PREPACK" DataTypeServer="NUMBER(22)" DbType="Decimal" Direction="Input" ParameterName=":PCONSECUTIVO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CONSECPREPACK" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="PIDPRODUCTOH" ColumnName="IDPRODUCTOH" DataSourceName="SAMUEL.INV_PREPACK" DataTypeServer="VARCHAR2(15)" DbType="String" Direction="Input" ParameterName=":PIDPRODUCTOH" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTOH" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="PNUMEROREGISTROH" ColumnName="NUMEROREGISTROH" DataSourceName="SAMUEL.INV_PREPACK" DataTypeServer="VARCHAR2(20)" DbType="String" Direction="Input" ParameterName=":PNUMEROREGISTROH" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="NUMEROREGISTROH" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="GetImeiAndIccidValido" Modifier="Public" Name="GetImeiAndIccidValido" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="GetImeiAndIccidValido">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT COUNT(*)
FROM INV_PREPACK
WHERE ((IDPRODUCTOP=:PIDPRODUCTO AND NUMEROREGISTROP=:PNUMEROREGISTRO) 
	OR (IDPRODUCTOH=:PIDPRODUCTO AND NUMEROREGISTROH=:PNUMEROREGISTRO))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="PIDPRODUCTO" ColumnName="IDPRODUCTOP" DataSourceName="SAMUEL.INV_PREPACK" DataTypeServer="VARCHAR2(15)" DbType="String" Direction="Input" ParameterName=":PIDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTOP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PNUMEROREGISTRO" ColumnName="NUMEROREGISTROP" DataSourceName="SAMUEL.INV_PREPACK" DataTypeServer="VARCHAR2(20)" DbType="String" Direction="Input" ParameterName=":PNUMEROREGISTRO" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="NUMEROREGISTROP" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="INV_TIPOSPREPACKSTableAdapter" GeneratorDataComponentClassName="INV_TIPOSPREPACKSTableAdapter" Name="INV_TIPOSPREPACKS" UserDataComponentName="INV_TIPOSPREPACKSTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.INV_TIPOSPREPACKS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "SAMUEL"."INV_TIPOSPREPACKS" WHERE (("IDPREPACK" = :Original_IDPREPACK) AND ("DESCRIPCION" = :Original_DESCRIPCION) AND ("CANTIMEI" = :Original_CANTIMEI) AND ("CANTICCID" = :Original_CANTICCID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_IDPREPACK" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="IDPREPACK" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="NVarchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_CANTIMEI" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CANTIMEI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_CANTICCID" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CANTICCID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "SAMUEL"."INV_TIPOSPREPACKS" ("IDPREPACK", "DESCRIPCION", "CANTIMEI", "CANTICCID") VALUES (:IDPREPACK, :DESCRIPCION, :CANTIMEI, :CANTICCID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="IDPREPACK" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="IDPREPACK" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="NVarchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="CANTIMEI" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CANTIMEI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="CANTICCID" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CANTICCID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDPREPACK, DESCRIPCION, CANTIMEI, CANTICCID FROM SAMUEL.INV_TIPOSPREPACKS</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "SAMUEL"."INV_TIPOSPREPACKS" SET "IDPREPACK" = :IDPREPACK, "DESCRIPCION" = :DESCRIPCION, "CANTIMEI" = :CANTIMEI, "CANTICCID" = :CANTICCID WHERE (("IDPREPACK" = :Original_IDPREPACK) AND ("DESCRIPCION" = :Original_DESCRIPCION) AND ("CANTIMEI" = :Original_CANTIMEI) AND ("CANTICCID" = :Original_CANTICCID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="IDPREPACK" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="IDPREPACK" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="NVarchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="CANTIMEI" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CANTIMEI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="CANTICCID" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CANTICCID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_IDPREPACK" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="IDPREPACK" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="NVarchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_CANTIMEI" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CANTIMEI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_CANTICCID" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CANTICCID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDPREPACK" DataSetColumn="IDPREPACK" />
              <Mapping SourceColumn="DESCRIPCION" DataSetColumn="DESCRIPCION" />
              <Mapping SourceColumn="CANTIMEI" DataSetColumn="CANTIMEI" />
              <Mapping SourceColumn="CANTICCID" DataSetColumn="CANTICCID" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.INV_TIPOSPREPACKS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdPreack" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdPreack" GeneratorSourceName="FillByIdPreack" GetMethodModifier="Public" GetMethodName="GetDataByIdPreack" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdPreack" UserSourceName="FillByIdPreack">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        IDPREPACK, DESCRIPCION, CANTIMEI, CANTICCID
FROM            INV_TIPOSPREPACKS
WHERE        (IDPREPACK = :IDPREPACK)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="IDPREPACK" ColumnName="IDPREPACK" DataSourceName="SAMUEL.INV_TIPOSPREPACKS" DataTypeServer="NUMBER(22)" DbType="Decimal" Direction="Input" ParameterName=":IDPREPACK" Precision="20" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="IDPREPACK" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="INV_BODEGASTableAdapter" GeneratorDataComponentClassName="INV_BODEGASTableAdapter" Name="INV_BODEGAS" UserDataComponentName="INV_BODEGASTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.INV_BODEGAS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "SAMUEL"."INV_BODEGAS" WHERE (("IDBODEGA" = :Original_IDBODEGA) AND ((:IsNull_IDSEDE = 1 AND "IDSEDE" IS NULL) OR ("IDSEDE" = :Original_IDSEDE)) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)) AND ((:IsNull_EXISTENCIACLIENTE = 1 AND "EXISTENCIACLIENTE" IS NULL) OR ("EXISTENCIACLIENTE" = :Original_EXISTENCIACLIENTE)) AND ((:IsNull_ACTIVA = 1 AND "ACTIVA" IS NULL) OR ("ACTIVA" = :Original_ACTIVA)) AND ((:IsNull_PERMITEFACTURAR = 1 AND "PERMITEFACTURAR" IS NULL) OR ("PERMITEFACTURAR" = :Original_PERMITEFACTURAR)) AND ((:IsNull_RESPONSABLE = 1 AND "RESPONSABLE" IS NULL) OR ("RESPONSABLE" = :Original_RESPONSABLE)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDBODEGA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDBODEGA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDSEDE" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDSEDE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDSEDE" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDSEDE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_EXISTENCIACLIENTE" Precision="0" ProviderType="Int32" Scale="0" Size="1" SourceColumn="EXISTENCIACLIENTE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_EXISTENCIACLIENTE" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="EXISTENCIACLIENTE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ACTIVA" Precision="0" ProviderType="Int32" Scale="0" Size="1" SourceColumn="ACTIVA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_ACTIVA" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="ACTIVA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PERMITEFACTURAR" Precision="0" ProviderType="Int32" Scale="0" Size="1" SourceColumn="PERMITEFACTURAR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_PERMITEFACTURAR" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="PERMITEFACTURAR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_RESPONSABLE" Precision="0" ProviderType="Int32" Scale="0" Size="50" SourceColumn="RESPONSABLE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_RESPONSABLE" Precision="0" ProviderType="Varchar2" Scale="0" Size="50" SourceColumn="RESPONSABLE" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "SAMUEL"."INV_BODEGAS" ("IDBODEGA", "IDSEDE", "DESCRIPCION", "EXISTENCIACLIENTE", "ACTIVA", "PERMITEFACTURAR", "RESPONSABLE") VALUES (:IDBODEGA, :IDSEDE, :DESCRIPCION, :EXISTENCIACLIENTE, :ACTIVA, :PERMITEFACTURAR, :RESPONSABLE)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDBODEGA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDBODEGA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDSEDE" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDSEDE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="EXISTENCIACLIENTE" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="EXISTENCIACLIENTE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="ACTIVA" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="ACTIVA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="PERMITEFACTURAR" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="PERMITEFACTURAR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="RESPONSABLE" Precision="0" ProviderType="Varchar2" Scale="0" Size="50" SourceColumn="RESPONSABLE" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDBODEGA, IDSEDE, DESCRIPCION, EXISTENCIACLIENTE, ACTIVA, PERMITEFACTURAR, RESPONSABLE FROM SAMUEL.INV_BODEGAS</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "SAMUEL"."INV_BODEGAS" SET "IDBODEGA" = :IDBODEGA, "IDSEDE" = :IDSEDE, "DESCRIPCION" = :DESCRIPCION, "EXISTENCIACLIENTE" = :EXISTENCIACLIENTE, "ACTIVA" = :ACTIVA, "PERMITEFACTURAR" = :PERMITEFACTURAR, "RESPONSABLE" = :RESPONSABLE WHERE (("IDBODEGA" = :Original_IDBODEGA) AND ((:IsNull_IDSEDE = 1 AND "IDSEDE" IS NULL) OR ("IDSEDE" = :Original_IDSEDE)) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)) AND ((:IsNull_EXISTENCIACLIENTE = 1 AND "EXISTENCIACLIENTE" IS NULL) OR ("EXISTENCIACLIENTE" = :Original_EXISTENCIACLIENTE)) AND ((:IsNull_ACTIVA = 1 AND "ACTIVA" IS NULL) OR ("ACTIVA" = :Original_ACTIVA)) AND ((:IsNull_PERMITEFACTURAR = 1 AND "PERMITEFACTURAR" IS NULL) OR ("PERMITEFACTURAR" = :Original_PERMITEFACTURAR)) AND ((:IsNull_RESPONSABLE = 1 AND "RESPONSABLE" IS NULL) OR ("RESPONSABLE" = :Original_RESPONSABLE)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDBODEGA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDBODEGA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDSEDE" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDSEDE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="EXISTENCIACLIENTE" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="EXISTENCIACLIENTE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="ACTIVA" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="ACTIVA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="PERMITEFACTURAR" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="PERMITEFACTURAR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="RESPONSABLE" Precision="0" ProviderType="Varchar2" Scale="0" Size="50" SourceColumn="RESPONSABLE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDBODEGA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDBODEGA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDSEDE" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDSEDE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDSEDE" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDSEDE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_EXISTENCIACLIENTE" Precision="0" ProviderType="Int32" Scale="0" Size="1" SourceColumn="EXISTENCIACLIENTE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_EXISTENCIACLIENTE" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="EXISTENCIACLIENTE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ACTIVA" Precision="0" ProviderType="Int32" Scale="0" Size="1" SourceColumn="ACTIVA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_ACTIVA" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="ACTIVA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PERMITEFACTURAR" Precision="0" ProviderType="Int32" Scale="0" Size="1" SourceColumn="PERMITEFACTURAR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_PERMITEFACTURAR" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="PERMITEFACTURAR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_RESPONSABLE" Precision="0" ProviderType="Int32" Scale="0" Size="50" SourceColumn="RESPONSABLE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_RESPONSABLE" Precision="0" ProviderType="Varchar2" Scale="0" Size="50" SourceColumn="RESPONSABLE" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDBODEGA" DataSetColumn="IDBODEGA" />
              <Mapping SourceColumn="IDSEDE" DataSetColumn="IDSEDE" />
              <Mapping SourceColumn="DESCRIPCION" DataSetColumn="DESCRIPCION" />
              <Mapping SourceColumn="EXISTENCIACLIENTE" DataSetColumn="EXISTENCIACLIENTE" />
              <Mapping SourceColumn="ACTIVA" DataSetColumn="ACTIVA" />
              <Mapping SourceColumn="PERMITEFACTURAR" DataSetColumn="PERMITEFACTURAR" />
              <Mapping SourceColumn="RESPONSABLE" DataSetColumn="RESPONSABLE" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.INV_BODEGAS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdBodega" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdBodega" GeneratorSourceName="FillByIdBodega" GetMethodModifier="Public" GetMethodName="GetDataByIdBodega" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdBodega" UserSourceName="FillByIdBodega">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ACTIVA, DESCRIPCION, EXISTENCIACLIENTE, IDBODEGA, IDSEDE, PERMITEFACTURAR, RESPONSABLE FROM INV_BODEGAS WHERE (IDBODEGA = :IDBODEGA)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="IDBODEGA" ColumnName="IDBODEGA" DataSourceName="SAMUEL.INV_BODEGAS" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":IDBODEGA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDBODEGA" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.INV_BODEGAS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdSede" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdSede" GeneratorSourceName="FillByIdSede" GetMethodModifier="Public" GetMethodName="GetDataByIdSede" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdSede" UserSourceName="FillByIdSede">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ACTIVA, DESCRIPCION, EXISTENCIACLIENTE, IDBODEGA, IDSEDE, PERMITEFACTURAR, RESPONSABLE FROM INV_BODEGAS WHERE (IDSEDE = :IDSEDE)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="IDSEDE" ColumnName="IDSEDE" DataSourceName="SAMUEL.INV_BODEGAS" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":IDSEDE" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDSEDE" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.INV_BODEGAS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBySedes" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBySedes" GeneratorSourceName="FillBySedes" GetMethodModifier="Public" GetMethodName="GetDataBySedes" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBySedes" UserSourceName="FillBySedes">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT IDBODEGA, IDSEDE, DESCRIPCION, EXISTENCIACLIENTE, ACTIVA, PERMITEFACTURAR, RESPONSABLE FROM SAMUEL.INV_BODEGAS
WHERE IDSEDE LIKE :PFILTRO</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="PFILTRO" ColumnName="IDSEDE" DataSourceName="SAMUEL.INV_BODEGAS" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PFILTRO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDSEDE" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.INV_BODEGAS" DbObjectType="Table" GenerateShortCommands="true" GeneratorSourceName="GetNombreBodega" Modifier="Public" Name="GetNombreBodega" QueryType="Scalar" ScalarCallRetval="System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="GetNombreBodega">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        DESCRIPCION
FROM            INV_BODEGAS
WHERE        (IDBODEGA = :IDBODEGA)
</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="IDBODEGA" ColumnName="IDBODEGA" DataSourceName="SAMUEL.INV_BODEGAS" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":IDBODEGA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDBODEGA" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dsInventarios" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="dsInventarios" msprop:Generator_DataSetName="dsInventarios" msprop:EnableTableAdapterManager="true">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="PRO_PRODUCTO" msprop:Generator_UserTableName="PRO_PRODUCTO" msprop:Generator_RowDeletedName="PRO_PRODUCTORowDeleted" msprop:Generator_RowChangedName="PRO_PRODUCTORowChanged" msprop:Generator_RowClassName="PRO_PRODUCTORow" msprop:Generator_RowChangingName="PRO_PRODUCTORowChanging" msprop:Generator_RowEvArgName="PRO_PRODUCTORowChangeEvent" msprop:Generator_RowEvHandlerName="PRO_PRODUCTORowChangeEventHandler" msprop:Generator_TableClassName="PRO_PRODUCTODataTable" msprop:Generator_TableVarName="tablePRO_PRODUCTO" msprop:Generator_RowDeletingName="PRO_PRODUCTORowDeleting" msprop:Generator_TablePropName="PRO_PRODUCTO">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDPRODUCTO" msprop:Generator_UserColumnName="IDPRODUCTO" msprop:Generator_ColumnPropNameInRow="IDPRODUCTO" msprop:Generator_ColumnVarNameInTable="columnIDPRODUCTO" msprop:Generator_ColumnPropNameInTable="IDPRODUCTOColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DESCRICION" msprop:Generator_UserColumnName="DESCRICION" msprop:Generator_ColumnPropNameInRow="DESCRICION" msprop:Generator_ColumnVarNameInTable="columnDESCRICION" msprop:Generator_ColumnPropNameInTable="DESCRICIONColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="APLICARANGODTO" msprop:Generator_UserColumnName="APLICARANGODTO" msprop:Generator_ColumnPropNameInRow="APLICARANGODTO" msprop:Generator_ColumnVarNameInTable="columnAPLICARANGODTO" msprop:Generator_ColumnPropNameInTable="APLICARANGODTOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CONTENIDO" msprop:Generator_UserColumnName="CONTENIDO" msprop:Generator_ColumnPropNameInRow="CONTENIDO" msprop:Generator_ColumnVarNameInTable="columnCONTENIDO" msprop:Generator_ColumnPropNameInTable="CONTENIDOColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="COSTO" msprop:Generator_UserColumnName="COSTO" msprop:Generator_ColumnPropNameInRow="COSTO" msprop:Generator_ColumnVarNameInTable="columnCOSTO" msprop:Generator_ColumnPropNameInTable="COSTOColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="EAN" msprop:Generator_UserColumnName="EAN" msprop:Generator_ColumnPropNameInRow="EAN" msprop:Generator_ColumnVarNameInTable="columnEAN" msprop:Generator_ColumnPropNameInTable="EANColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ESTADO" msprop:Generator_UserColumnName="ESTADO" msprop:Generator_ColumnPropNameInRow="ESTADO" msprop:Generator_ColumnVarNameInTable="columnESTADO" msprop:Generator_ColumnPropNameInTable="ESTADOColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="IDTIPOIVA" msprop:Generator_UserColumnName="IDTIPOIVA" msprop:Generator_ColumnPropNameInRow="IDTIPOIVA" msprop:Generator_ColumnVarNameInTable="columnIDTIPOIVA" msprop:Generator_ColumnPropNameInTable="IDTIPOIVAColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDTIPOPRODUCTO" msprop:Generator_UserColumnName="IDTIPOPRODUCTO" msprop:Generator_ColumnPropNameInRow="IDTIPOPRODUCTO" msprop:Generator_ColumnVarNameInTable="columnIDTIPOPRODUCTO" msprop:Generator_ColumnPropNameInTable="IDTIPOPRODUCTOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="REFERENCIA" msprop:Generator_UserColumnName="REFERENCIA" msprop:Generator_ColumnPropNameInRow="REFERENCIA" msprop:Generator_ColumnVarNameInTable="columnREFERENCIA" msprop:Generator_ColumnPropNameInTable="REFERENCIAColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UNIDAD" msprop:Generator_UserColumnName="UNIDAD" msprop:Generator_ColumnPropNameInRow="UNIDAD" msprop:Generator_ColumnVarNameInTable="columnUNIDAD" msprop:Generator_ColumnPropNameInTable="UNIDADColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PRO_TIPOPRODUCTO" msprop:Generator_UserTableName="PRO_TIPOPRODUCTO" msprop:Generator_RowDeletedName="PRO_TIPOPRODUCTORowDeleted" msprop:Generator_RowChangedName="PRO_TIPOPRODUCTORowChanged" msprop:Generator_RowClassName="PRO_TIPOPRODUCTORow" msprop:Generator_RowChangingName="PRO_TIPOPRODUCTORowChanging" msprop:Generator_RowEvArgName="PRO_TIPOPRODUCTORowChangeEvent" msprop:Generator_RowEvHandlerName="PRO_TIPOPRODUCTORowChangeEventHandler" msprop:Generator_TableClassName="PRO_TIPOPRODUCTODataTable" msprop:Generator_TableVarName="tablePRO_TIPOPRODUCTO" msprop:Generator_RowDeletingName="PRO_TIPOPRODUCTORowDeleting" msprop:Generator_TablePropName="PRO_TIPOPRODUCTO">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDTIPOPRODUCTO" msprop:Generator_UserColumnName="IDTIPOPRODUCTO" msprop:Generator_ColumnPropNameInRow="IDTIPOPRODUCTO" msprop:Generator_ColumnVarNameInTable="columnIDTIPOPRODUCTO" msprop:Generator_ColumnPropNameInTable="IDTIPOPRODUCTOColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DESCRIPCION" msprop:Generator_UserColumnName="DESCRIPCION" msprop:Generator_ColumnPropNameInRow="DESCRIPCION" msprop:Generator_ColumnVarNameInTable="columnDESCRIPCION" msprop:Generator_ColumnPropNameInTable="DESCRIPCIONColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="INV_INVENTARIOS" msprop:Generator_UserTableName="INV_INVENTARIOS" msprop:Generator_RowDeletedName="INV_INVENTARIOSRowDeleted" msprop:Generator_RowChangedName="INV_INVENTARIOSRowChanged" msprop:Generator_RowClassName="INV_INVENTARIOSRow" msprop:Generator_RowChangingName="INV_INVENTARIOSRowChanging" msprop:Generator_RowEvArgName="INV_INVENTARIOSRowChangeEvent" msprop:Generator_RowEvHandlerName="INV_INVENTARIOSRowChangeEventHandler" msprop:Generator_TableClassName="INV_INVENTARIOSDataTable" msprop:Generator_TableVarName="tableINV_INVENTARIOS" msprop:Generator_RowDeletingName="INV_INVENTARIOSRowDeleting" msprop:Generator_TablePropName="INV_INVENTARIOS">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDBODEGA" msprop:Generator_UserColumnName="IDBODEGA" msprop:Generator_ColumnPropNameInRow="IDBODEGA" msprop:Generator_ColumnVarNameInTable="columnIDBODEGA" msprop:Generator_ColumnPropNameInTable="IDBODEGAColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDPRODUCTO" msprop:Generator_UserColumnName="IDPRODUCTO" msprop:Generator_ColumnPropNameInRow="IDPRODUCTO" msprop:Generator_ColumnVarNameInTable="columnIDPRODUCTO" msprop:Generator_ColumnPropNameInTable="IDPRODUCTOColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PERIODO" msprop:Generator_UserColumnName="PERIODO" msprop:Generator_ColumnPropNameInRow="PERIODO" msprop:Generator_ColumnVarNameInTable="columnPERIODO" msprop:Generator_ColumnPropNameInTable="PERIODOColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="6" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDCLIENTE" msprop:Generator_UserColumnName="IDCLIENTE" msprop:Generator_ColumnPropNameInRow="IDCLIENTE" msprop:Generator_ColumnVarNameInTable="columnIDCLIENTE" msprop:Generator_ColumnPropNameInTable="IDCLIENTEColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="COMPRA" msprop:Generator_UserColumnName="COMPRA" msprop:Generator_ColumnPropNameInRow="COMPRA" msprop:Generator_ColumnVarNameInTable="columnCOMPRA" msprop:Generator_ColumnPropNameInTable="COMPRAColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="COSTOPROMEDIO" msprop:Generator_UserColumnName="COSTOPROMEDIO" msprop:Generator_ColumnPropNameInRow="COSTOPROMEDIO" msprop:Generator_ColumnVarNameInTable="columnCOSTOPROMEDIO" msprop:Generator_ColumnPropNameInTable="COSTOPROMEDIOColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ENTRADAS" msprop:Generator_UserColumnName="ENTRADAS" msprop:Generator_ColumnPropNameInRow="ENTRADAS" msprop:Generator_ColumnVarNameInTable="columnENTRADAS" msprop:Generator_ColumnPropNameInTable="ENTRADASColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="SALDOINICIAL" msprop:Generator_UserColumnName="SALDOINICIAL" msprop:Generator_ColumnPropNameInRow="SALDOINICIAL" msprop:Generator_ColumnVarNameInTable="columnSALDOINICIAL" msprop:Generator_ColumnPropNameInTable="SALDOINICIALColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="SALIDAS" msprop:Generator_UserColumnName="SALIDAS" msprop:Generator_ColumnPropNameInRow="SALIDAS" msprop:Generator_ColumnVarNameInTable="columnSALIDAS" msprop:Generator_ColumnPropNameInTable="SALIDASColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="VENTAPROMEDIO" msprop:Generator_UserColumnName="VENTAPROMEDIO" msprop:Generator_ColumnPropNameInRow="VENTAPROMEDIO" msprop:Generator_ColumnVarNameInTable="columnVENTAPROMEDIO" msprop:Generator_ColumnPropNameInTable="VENTAPROMEDIOColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="VENTAS" msprop:Generator_UserColumnName="VENTAS" msprop:Generator_ColumnPropNameInRow="VENTAS" msprop:Generator_ColumnVarNameInTable="columnVENTAS" msprop:Generator_ColumnPropNameInTable="VENTASColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ENTRADASPROMEDIO" msprop:Generator_UserColumnName="ENTRADASPROMEDIO" msprop:Generator_ColumnPropNameInRow="ENTRADASPROMEDIO" msprop:Generator_ColumnVarNameInTable="columnENTRADASPROMEDIO" msprop:Generator_ColumnPropNameInTable="ENTRADASPROMEDIOColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="SALIDASPROMEDIO" msprop:Generator_UserColumnName="SALIDASPROMEDIO" msprop:Generator_ColumnPropNameInRow="SALIDASPROMEDIO" msprop:Generator_ColumnVarNameInTable="columnSALIDASPROMEDIO" msprop:Generator_ColumnPropNameInTable="SALIDASPROMEDIOColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="INICIALPROMEDIO" msprop:Generator_UserColumnName="INICIALPROMEDIO" msprop:Generator_ColumnPropNameInRow="INICIALPROMEDIO" msprop:Generator_ColumnVarNameInTable="columnINICIALPROMEDIO" msprop:Generator_ColumnPropNameInTable="INICIALPROMEDIOColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="SALDO" msdata:ReadOnly="true" msprop:Generator_UserColumnName="SALDO" msprop:Generator_ColumnPropNameInRow="SALDO" msprop:Generator_ColumnVarNameInTable="columnSALDO" msprop:Generator_ColumnPropNameInTable="SALDOColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="INV_DETALLEINVENTARIOS" msprop:Generator_UserTableName="INV_DETALLEINVENTARIOS" msprop:Generator_RowDeletedName="INV_DETALLEINVENTARIOSRowDeleted" msprop:Generator_RowChangedName="INV_DETALLEINVENTARIOSRowChanged" msprop:Generator_RowClassName="INV_DETALLEINVENTARIOSRow" msprop:Generator_RowChangingName="INV_DETALLEINVENTARIOSRowChanging" msprop:Generator_RowEvArgName="INV_DETALLEINVENTARIOSRowChangeEvent" msprop:Generator_RowEvHandlerName="INV_DETALLEINVENTARIOSRowChangeEventHandler" msprop:Generator_TableClassName="INV_DETALLEINVENTARIOSDataTable" msprop:Generator_TableVarName="tableINV_DETALLEINVENTARIOS" msprop:Generator_RowDeletingName="INV_DETALLEINVENTARIOSRowDeleting" msprop:Generator_TablePropName="INV_DETALLEINVENTARIOS">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDBODEGA" msprop:Generator_UserColumnName="IDBODEGA" msprop:Generator_ColumnPropNameInRow="IDBODEGA" msprop:Generator_ColumnVarNameInTable="columnIDBODEGA" msprop:Generator_ColumnPropNameInTable="IDBODEGAColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDPRODUCTO" msprop:Generator_UserColumnName="IDPRODUCTO" msprop:Generator_ColumnPropNameInRow="IDPRODUCTO" msprop:Generator_ColumnVarNameInTable="columnIDPRODUCTO" msprop:Generator_ColumnPropNameInTable="IDPRODUCTOColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CONSECUTIVO" msprop:Generator_UserColumnName="CONSECUTIVO" msprop:Generator_ColumnPropNameInRow="CONSECUTIVO" msprop:Generator_ColumnVarNameInTable="columnCONSECUTIVO" msprop:Generator_ColumnPropNameInTable="CONSECUTIVOColumn" type="xs:decimal" />
              <xs:element name="IMEI" msprop:Generator_UserColumnName="IMEI" msprop:Generator_ColumnPropNameInRow="IMEI" msprop:Generator_ColumnVarNameInTable="columnIMEI" msprop:Generator_ColumnPropNameInTable="IMEIColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ICCID" msprop:Generator_UserColumnName="ICCID" msprop:Generator_ColumnPropNameInRow="ICCID" msprop:Generator_ColumnVarNameInTable="columnICCID" msprop:Generator_ColumnPropNameInTable="ICCIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="COSTO" msprop:Generator_UserColumnName="COSTO" msprop:Generator_ColumnPropNameInRow="COSTO" msprop:Generator_ColumnVarNameInTable="columnCOSTO" msprop:Generator_ColumnPropNameInTable="COSTOColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="FECHAINGRESO" msprop:Generator_UserColumnName="FECHAINGRESO" msprop:Generator_ColumnPropNameInRow="FECHAINGRESO" msprop:Generator_ColumnVarNameInTable="columnFECHAINGRESO" msprop:Generator_ColumnPropNameInTable="FECHAINGRESOColumn" type="xs:dateTime" />
              <xs:element name="SALDO" msprop:Generator_UserColumnName="SALDO" msprop:Generator_ColumnPropNameInRow="SALDO" msprop:Generator_ColumnVarNameInTable="columnSALDO" msprop:Generator_ColumnPropNameInTable="SALDOColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="INV_DETALLE" msprop:Generator_UserTableName="INV_DETALLE" msprop:Generator_RowDeletedName="INV_DETALLERowDeleted" msprop:Generator_RowChangedName="INV_DETALLERowChanged" msprop:Generator_RowClassName="INV_DETALLERow" msprop:Generator_RowChangingName="INV_DETALLERowChanging" msprop:Generator_RowEvArgName="INV_DETALLERowChangeEvent" msprop:Generator_RowEvHandlerName="INV_DETALLERowChangeEventHandler" msprop:Generator_TableClassName="INV_DETALLEDataTable" msprop:Generator_TableVarName="tableINV_DETALLE" msprop:Generator_RowDeletingName="INV_DETALLERowDeleting" msprop:Generator_TablePropName="INV_DETALLE">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDBODEGA" msprop:Generator_UserColumnName="IDBODEGA" msprop:Generator_ColumnPropNameInRow="IDBODEGA" msprop:Generator_ColumnVarNameInTable="columnIDBODEGA" msprop:Generator_ColumnPropNameInTable="IDBODEGAColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDPRODUCTO" msprop:Generator_UserColumnName="IDPRODUCTO" msprop:Generator_ColumnPropNameInRow="IDPRODUCTO" msprop:Generator_ColumnVarNameInTable="columnIDPRODUCTO" msprop:Generator_ColumnPropNameInTable="IDPRODUCTOColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TIPOSUBPROD" msprop:Generator_UserColumnName="TIPOSUBPROD" msprop:Generator_ColumnPropNameInRow="TIPOSUBPROD" msprop:Generator_ColumnVarNameInTable="columnTIPOSUBPROD" msprop:Generator_ColumnPropNameInTable="TIPOSUBPRODColumn" type="xs:decimal" />
              <xs:element name="NUMEROREGISTRO" msprop:Generator_UserColumnName="NUMEROREGISTRO" msprop:Generator_ColumnPropNameInRow="NUMEROREGISTRO" msprop:Generator_ColumnVarNameInTable="columnNUMEROREGISTRO" msprop:Generator_ColumnPropNameInTable="NUMEROREGISTROColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="COSTO" msprop:Generator_UserColumnName="COSTO" msprop:Generator_ColumnPropNameInRow="COSTO" msprop:Generator_ColumnVarNameInTable="columnCOSTO" msprop:Generator_ColumnPropNameInTable="COSTOColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="FECHAINGRESO" msprop:Generator_UserColumnName="FECHAINGRESO" msprop:Generator_ColumnPropNameInRow="FECHAINGRESO" msprop:Generator_ColumnVarNameInTable="columnFECHAINGRESO" msprop:Generator_ColumnPropNameInTable="FECHAINGRESOColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="CONSECUTIVO" msprop:Generator_UserColumnName="CONSECUTIVO" msprop:Generator_ColumnVarNameInTable="columnCONSECUTIVO" msprop:Generator_ColumnPropNameInRow="CONSECUTIVO" msprop:Generator_ColumnPropNameInTable="CONSECUTIVOColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="PAREJA" msprop:Generator_UserColumnName="PAREJA" msprop:Generator_ColumnVarNameInTable="columnPAREJA" msprop:Generator_ColumnPropNameInRow="PAREJA" msprop:Generator_ColumnPropNameInTable="PAREJAColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="INV_PREPACK" msprop:Generator_UserTableName="INV_PREPACK" msprop:Generator_RowDeletedName="INV_PREPACKRowDeleted" msprop:Generator_RowChangedName="INV_PREPACKRowChanged" msprop:Generator_RowClassName="INV_PREPACKRow" msprop:Generator_RowChangingName="INV_PREPACKRowChanging" msprop:Generator_RowEvArgName="INV_PREPACKRowChangeEvent" msprop:Generator_RowEvHandlerName="INV_PREPACKRowChangeEventHandler" msprop:Generator_TableClassName="INV_PREPACKDataTable" msprop:Generator_TableVarName="tableINV_PREPACK" msprop:Generator_RowDeletingName="INV_PREPACKRowDeleting" msprop:Generator_TablePropName="INV_PREPACK">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDPREPACK" msprop:Generator_UserColumnName="IDPREPACK" msprop:Generator_ColumnPropNameInRow="IDPREPACK" msprop:Generator_ColumnVarNameInTable="columnIDPREPACK" msprop:Generator_ColumnPropNameInTable="IDPREPACKColumn" type="xs:decimal" />
              <xs:element name="CONSECPREPACK" msprop:Generator_UserColumnName="CONSECPREPACK" msprop:Generator_ColumnPropNameInRow="CONSECPREPACK" msprop:Generator_ColumnVarNameInTable="columnCONSECPREPACK" msprop:Generator_ColumnPropNameInTable="CONSECPREPACKColumn" type="xs:decimal" />
              <xs:element name="COSTO" msprop:Generator_UserColumnName="COSTO" msprop:Generator_ColumnPropNameInRow="COSTO" msprop:Generator_ColumnVarNameInTable="columnCOSTO" msprop:Generator_ColumnPropNameInTable="COSTOColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="FECHAPREPACK" msprop:Generator_UserColumnName="FECHAPREPACK" msprop:Generator_ColumnPropNameInRow="FECHAPREPACK" msprop:Generator_ColumnVarNameInTable="columnFECHAPREPACK" msprop:Generator_ColumnPropNameInTable="FECHAPREPACKColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ESTADO" msprop:Generator_UserColumnName="ESTADO" msprop:Generator_ColumnPropNameInRow="ESTADO" msprop:Generator_ColumnVarNameInTable="columnESTADO" msprop:Generator_ColumnPropNameInTable="ESTADOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDPRODUCTOP" msprop:Generator_UserColumnName="IDPRODUCTOP" msprop:Generator_ColumnPropNameInRow="IDPRODUCTOP" msprop:Generator_ColumnVarNameInTable="columnIDPRODUCTOP" msprop:Generator_ColumnPropNameInTable="IDPRODUCTOPColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDPRODUCTOH" msprop:Generator_UserColumnName="IDPRODUCTOH" msprop:Generator_ColumnPropNameInRow="IDPRODUCTOH" msprop:Generator_ColumnVarNameInTable="columnIDPRODUCTOH" msprop:Generator_ColumnPropNameInTable="IDPRODUCTOHColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TIPOSUBPROP" msprop:Generator_UserColumnName="TIPOSUBPROP" msprop:Generator_ColumnVarNameInTable="columnTIPOSUBPROP" msprop:Generator_ColumnPropNameInRow="TIPOSUBPROP" msprop:Generator_ColumnPropNameInTable="TIPOSUBPROPColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="NUMEROREGISTROP" msprop:Generator_UserColumnName="NUMEROREGISTROP" msprop:Generator_ColumnVarNameInTable="columnNUMEROREGISTROP" msprop:Generator_ColumnPropNameInRow="NUMEROREGISTROP" msprop:Generator_ColumnPropNameInTable="NUMEROREGISTROPColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TIPOSUBPRODH" msprop:Generator_UserColumnName="TIPOSUBPRODH" msprop:Generator_ColumnVarNameInTable="columnTIPOSUBPRODH" msprop:Generator_ColumnPropNameInRow="TIPOSUBPRODH" msprop:Generator_ColumnPropNameInTable="TIPOSUBPRODHColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="NUMEROREGISTROH" msprop:Generator_UserColumnName="NUMEROREGISTROH" msprop:Generator_ColumnVarNameInTable="columnNUMEROREGISTROH" msprop:Generator_ColumnPropNameInRow="NUMEROREGISTROH" msprop:Generator_ColumnPropNameInTable="NUMEROREGISTROHColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PAREJA" msprop:Generator_UserColumnName="PAREJA" msprop:Generator_ColumnPropNameInRow="PAREJA" msprop:Generator_ColumnVarNameInTable="columnPAREJA" msprop:Generator_ColumnPropNameInTable="PAREJAColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDTIPOPREPACK" msprop:Generator_UserColumnName="IDTIPOPREPACK" msprop:Generator_ColumnPropNameInRow="IDTIPOPREPACK" msprop:Generator_ColumnVarNameInTable="columnIDTIPOPREPACK" msprop:Generator_ColumnPropNameInTable="IDTIPOPREPACKColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="INV_TIPOSPREPACKS" msprop:Generator_UserTableName="INV_TIPOSPREPACKS" msprop:Generator_RowDeletedName="INV_TIPOSPREPACKSRowDeleted" msprop:Generator_RowChangedName="INV_TIPOSPREPACKSRowChanged" msprop:Generator_RowClassName="INV_TIPOSPREPACKSRow" msprop:Generator_RowChangingName="INV_TIPOSPREPACKSRowChanging" msprop:Generator_RowEvArgName="INV_TIPOSPREPACKSRowChangeEvent" msprop:Generator_RowEvHandlerName="INV_TIPOSPREPACKSRowChangeEventHandler" msprop:Generator_TableClassName="INV_TIPOSPREPACKSDataTable" msprop:Generator_TableVarName="tableINV_TIPOSPREPACKS" msprop:Generator_RowDeletingName="INV_TIPOSPREPACKSRowDeleting" msprop:Generator_TablePropName="INV_TIPOSPREPACKS">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDPREPACK" msprop:Generator_UserColumnName="IDPREPACK" msprop:Generator_ColumnVarNameInTable="columnIDPREPACK" msprop:Generator_ColumnPropNameInRow="IDPREPACK" msprop:Generator_ColumnPropNameInTable="IDPREPACKColumn" type="xs:decimal" />
              <xs:element name="DESCRIPCION" msprop:Generator_UserColumnName="DESCRIPCION" msprop:Generator_ColumnVarNameInTable="columnDESCRIPCION" msprop:Generator_ColumnPropNameInRow="DESCRIPCION" msprop:Generator_ColumnPropNameInTable="DESCRIPCIONColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CANTIMEI" msprop:Generator_UserColumnName="CANTIMEI" msprop:Generator_ColumnVarNameInTable="columnCANTIMEI" msprop:Generator_ColumnPropNameInRow="CANTIMEI" msprop:Generator_ColumnPropNameInTable="CANTIMEIColumn" type="xs:decimal" />
              <xs:element name="CANTICCID" msprop:Generator_UserColumnName="CANTICCID" msprop:Generator_ColumnVarNameInTable="columnCANTICCID" msprop:Generator_ColumnPropNameInRow="CANTICCID" msprop:Generator_ColumnPropNameInTable="CANTICCIDColumn" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="INV_BODEGAS" msprop:Generator_UserTableName="INV_BODEGAS" msprop:Generator_RowDeletedName="INV_BODEGASRowDeleted" msprop:Generator_RowChangedName="INV_BODEGASRowChanged" msprop:Generator_RowClassName="INV_BODEGASRow" msprop:Generator_RowChangingName="INV_BODEGASRowChanging" msprop:Generator_RowEvArgName="INV_BODEGASRowChangeEvent" msprop:Generator_RowEvHandlerName="INV_BODEGASRowChangeEventHandler" msprop:Generator_TableClassName="INV_BODEGASDataTable" msprop:Generator_TableVarName="tableINV_BODEGAS" msprop:Generator_RowDeletingName="INV_BODEGASRowDeleting" msprop:Generator_TablePropName="INV_BODEGAS">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDBODEGA" msprop:Generator_UserColumnName="IDBODEGA" msprop:Generator_ColumnVarNameInTable="columnIDBODEGA" msprop:Generator_ColumnPropNameInRow="IDBODEGA" msprop:Generator_ColumnPropNameInTable="IDBODEGAColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDSEDE" msprop:Generator_UserColumnName="IDSEDE" msprop:Generator_ColumnVarNameInTable="columnIDSEDE" msprop:Generator_ColumnPropNameInRow="IDSEDE" msprop:Generator_ColumnPropNameInTable="IDSEDEColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DESCRIPCION" msprop:Generator_UserColumnName="DESCRIPCION" msprop:Generator_ColumnVarNameInTable="columnDESCRIPCION" msprop:Generator_ColumnPropNameInRow="DESCRIPCION" msprop:Generator_ColumnPropNameInTable="DESCRIPCIONColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EXISTENCIACLIENTE" msprop:Generator_UserColumnName="EXISTENCIACLIENTE" msprop:Generator_ColumnVarNameInTable="columnEXISTENCIACLIENTE" msprop:Generator_ColumnPropNameInRow="EXISTENCIACLIENTE" msprop:Generator_ColumnPropNameInTable="EXISTENCIACLIENTEColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ACTIVA" msprop:Generator_UserColumnName="ACTIVA" msprop:Generator_ColumnVarNameInTable="columnACTIVA" msprop:Generator_ColumnPropNameInRow="ACTIVA" msprop:Generator_ColumnPropNameInTable="ACTIVAColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PERMITEFACTURAR" msprop:Generator_UserColumnName="PERMITEFACTURAR" msprop:Generator_ColumnVarNameInTable="columnPERMITEFACTURAR" msprop:Generator_ColumnPropNameInRow="PERMITEFACTURAR" msprop:Generator_ColumnPropNameInTable="PERMITEFACTURARColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RESPONSABLE" msprop:Generator_UserColumnName="RESPONSABLE" msprop:Generator_ColumnVarNameInTable="columnRESPONSABLE" msprop:Generator_ColumnPropNameInRow="RESPONSABLE" msprop:Generator_ColumnPropNameInTable="RESPONSABLEColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PRO_PRODUCTO" />
      <xs:field xpath="mstns:IDPRODUCTO" />
    </xs:unique>
    <xs:unique name="Constraint2">
      <xs:selector xpath=".//mstns:PRO_PRODUCTO" />
      <xs:field xpath="mstns:IDTIPOPRODUCTO" />
    </xs:unique>
    <xs:unique name="PRO_TIPOPRODUCTO_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PRO_TIPOPRODUCTO" />
      <xs:field xpath="mstns:IDTIPOPRODUCTO" />
    </xs:unique>
    <xs:unique name="INV_INVENTARIOS_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:INV_INVENTARIOS" />
      <xs:field xpath="mstns:IDBODEGA" />
      <xs:field xpath="mstns:IDPRODUCTO" />
      <xs:field xpath="mstns:PERIODO" />
      <xs:field xpath="mstns:IDCLIENTE" />
    </xs:unique>
    <xs:unique name="INV_DETALLEINVENTARIOS_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:INV_DETALLEINVENTARIOS" />
      <xs:field xpath="mstns:IDBODEGA" />
      <xs:field xpath="mstns:IDPRODUCTO" />
      <xs:field xpath="mstns:CONSECUTIVO" />
      <xs:field xpath="mstns:IMEI" />
      <xs:field xpath="mstns:ICCID" />
      <xs:field xpath="mstns:FECHAINGRESO" />
    </xs:unique>
    <xs:unique name="INV_DETALLEKey1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:INV_DETALLE" />
      <xs:field xpath="mstns:IDBODEGA" />
      <xs:field xpath="mstns:IDPRODUCTO" />
      <xs:field xpath="mstns:TIPOSUBPROD" />
      <xs:field xpath="mstns:NUMEROREGISTRO" />
      <xs:field xpath="mstns:PAREJA" />
    </xs:unique>
    <xs:unique name="INV_PREPACK_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:INV_PREPACK" />
      <xs:field xpath="mstns:IDPREPACK" />
      <xs:field xpath="mstns:CONSECPREPACK" />
      <xs:field xpath="mstns:NUMEROREGISTROP" />
    </xs:unique>
    <xs:unique name="INV_TIPOSPREPACKS_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:INV_TIPOSPREPACKS" />
      <xs:field xpath="mstns:IDPREPACK" />
    </xs:unique>
    <xs:unique name="INV_BODEGAS_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:INV_BODEGAS" />
      <xs:field xpath="mstns:IDBODEGA" />
    </xs:unique>
    <xs:keyref name="PRO_PRODUCTO_PRO_TIPOPRODUCTO" refer="Constraint2" msprop:rel_Generator_UserRelationName="PRO_PRODUCTO_PRO_TIPOPRODUCTO" msprop:rel_Generator_RelationVarName="relationPRO_PRODUCTO_PRO_TIPOPRODUCTO" msprop:rel_Generator_UserChildTable="PRO_TIPOPRODUCTO" msprop:rel_Generator_UserParentTable="PRO_PRODUCTO" msprop:rel_Generator_ParentPropName="PRO_PRODUCTORow" msprop:rel_Generator_ChildPropName="GetPRO_TIPOPRODUCTORows">
      <xs:selector xpath=".//mstns:PRO_TIPOPRODUCTO" />
      <xs:field xpath="mstns:IDTIPOPRODUCTO" />
    </xs:keyref>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_INVENTARIOS_BODEGAS" msdata:parent="INV_BODEGAS" msdata:child="INV_INVENTARIOS" msdata:parentkey="IDBODEGA" msdata:childkey="IDBODEGA" msprop:Generator_UserRelationName="FK_INVENTARIOS_BODEGAS" msprop:Generator_RelationVarName="relationFK_INVENTARIOS_BODEGAS" msprop:Generator_UserChildTable="INV_INVENTARIOS" msprop:Generator_UserParentTable="INV_BODEGAS" msprop:Generator_ParentPropName="INV_BODEGASRow" msprop:Generator_ChildPropName="GetINV_INVENTARIOSRows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>